Main
Kyle McGillicuddy-Penna
I have made visualizations viewed by hundreds of thousands of people, sped up query times for 25 terabytes of data by an average of 4,800 times, and built packages for R that let you do magic.
Currently searching for a position that allows me to build tools leveraging a combination of visualization, machine learning, and software engineering to help people explore and understand their data in new and useful ways.
Skills
Communication: action oriented translator.
N/A
N/A
N/A
- Proven ability to connect with stakeholders across functions, teams, and experience levels.
- Practiced listener, precise speaker, analytical thinker.
- Eliminate vagueness, even while describing complexity or uncertainty.
- Ask hard questions and push for answers that drive improvements.
- Graphical communication via Tableau, R, Excel.
Data access: experienced SQL writer, reader, and editor.
N/A
N/A
N/A
- PLSQL package development.
- Query optimization in a medium to large (billion row, non-distributed) data setting.
Data analysis: R to read, wrangle, explore, visualize, and model, mostly via the tidyverse.
N/A
N/A
N/A
Data storage (warehousing + ETL) via:
N/A
N/A
N/A
- Dimensional modeling: star + snowflake schemas + Kimball best practices.
- Database design: table creation and data normalization, data typing, constraints, indexes.
- PLSQL: scheduler + packages + triggers + stored procedures.
- Pentaho’s Data Integration.
- Cron + shell scripts.
Education
B.A. in Engineering Psychology
Tufts University
Medford & Boston, Massachusetts.
2004 - 2000
- Honors, Dean’s List.
Selected Positions
YOU Technology
Business Intelligence Lead
N/A
2020 - 2010
- Focus on scaling data resources to support 100%+ yearly customer and revenue growth over multiple years.
- Own data related product development process: ensure clear and achievable requirements, leading to better tools to inform decision makers.
- Hire, manage, and mentor a small team of engineers and analysts.
YOU Technology
Senior Business Analyst
N/A
2010 - 2006
- Collaborate with management to identify, track, and present best metrics of business impact; present those metrics to team leaders via executive dashboards.
- Build and maintain data warehouse and client facing reporting site to allow retailers to independently monitor and analyze campaigns.